<?php
    require_once './hopkins-ran/constants.php';
	$con = get_connection();
	echo "CON", $con;
    $seatchart = simplexml_load_file('seatchart.xml');
	echo $seatchart->section1[0]['name'];
    echo "<ul id='seatchart'>";
    foreach ($seatchart as $section1):	    
	    foreach ($section1 as $row):
		     echo $row['name'];
		     foreach ($row as $seat):
			      $seatname = $seat['name'];
				  $seatprice = $seat->price;
			      echo "<li><div class='Seat Number'>",$seatname,"</div><div class='Price'>",$seatprice,"</div></li>";
			 endforeach;
		endforeach;
    endforeach;
	close_connection($con);
    echo "</ul>";	
?>